﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
create PROCEDURE [dbo].[proc_Post_Amount]
	(
		@Pid INT,
		@Cid INT
	)
AS
BEGIN
	    
	SELECT  a.PostId, a.Amount FROM  Employee_Allowance AS a WHERE a.Pid=@Pid AND a.Cid=@Cid
	
END